Components of a Database

A database consists of several different components. Each component listed, is called an object.  A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS). Bit (Character) - a bit is the smallest unit of data representation (value of a bit may be a 0 or 1)

Database components are described below:

1. Tables These are the building blocks or relation of any relational database model where all the actual data is defined and entered. Different types of operation are done on the tables such as storing, filtering, retrieving and editing of data. Tables consist of cells at the intersection of records (rows)) and fields (columns), which are described below.

(i) Field: a field consists of a grouping of characters. It is an area (within the record) reserved for a specific piece of data. E.g. Customer number, customer name, street address, city, state, phone number, current address etc. Field of a table is also known as column.

(ii) Record It is the collection of data items of all the fields pertaining to one entity, 1.e. a person, company, transition, etc. Record of a table is also known as row or a tuple and the number of records in a relation is called the cardinality of that relation.

2. Queries These are basically questions based on the data available in a database. A query consists of specifications indicating which fields, records and summaries a user wants to fetch from a database. Queries allow you to extract data based on the criteria that you define.

3. Forms Although you can enter and modify data in datasheet view of tables but you neither control the user's action very well nor you can do much to facilitate the data - entry process. To overcome this problem, forms are introduced.

Like tables, forms can be used to view and edit your data. However, forms are typically used to view the data in an underlying table one record at a time.

e.g. A user can create a data entry form that looks exactly like a paper form. People generally prefer to enter data into a well-designed form, rather than a table.

4. Reports When you want to print those records which are fetched from your database, design a report. Access even has a wizard to help produce mailing labels.

5. Data is a collection of facts in raw or unorganized form (such as alphabets, numbers or symbols) that refer to or represent conditions, ideas or objects.

In the Question:

Row is also known as____________

Column is also known as__________

The Answer is Tuple.Field.

Hence the Option C is Correct.

Data is a collection of facts in raw or unorganized form (such as alphabets, numbers or symbols) that refer to or represent conditions, ideas or objects.

Components of a Database

A database consists of several different components. Each component listed, is called an object.  A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS). Bit (Character) - a bit is the smallest unit of data representation (value of a bit may be a 0 or 1)

Database components are described below:

1. Tables These are the building blocks or relation of any relational database model where all the actual data is defined and entered. Different types of operation are done on the tables such as storing, filtering, retrieving and editing of data. Tables consist of cells at the intersection of records (rows)) and fields (columns), which are described below.

(i) Field: a field consists of a grouping of characters. It is an area (within the record) reserved for a specific piece of data. E.g. Customer number, customer name, street address, city, state, phone number, current address etc. Field of a table is also known as column.

(ii) Record It is the collection of data items of all the fields pertaining to one entity, 1.e. a person, company, transition, etc. Record of a table is also known as row or a tuple and the number of records in a relation is called the cardinality of that relation.

2. Queries These are basically questions based on the data available in a database. A query consists of specifications indicating which fields, records and summaries a user wants to fetch from a database. Queries allow you to extract data based on the criteria that you define.

3. Forms Although you can enter and modify data in datasheet view of tables but you neither control the user's action very well nor you can do much to facilitate the data - entry process. To overcome this problem, forms are introduced.

Like tables, forms can be used to view and edit your data. However, forms are typically used to view the data in an underlying table one record at a time.

e.g. A user can create a data entry form that looks exactly like a paper form. People generally prefer to enter data into a well-designed form, rather than a table.

4. Reports When you want to print those records which are fetched from your database, design a report. Access even has a wizard to help produce mailing labels.

5. Data is a collection of facts in raw or unorganized form (such as alphabets, numbers or symbols) that refer to or represent conditions, ideas or objects.

In the Question:

_________consists of a grouping of characters. It is an area (within the record) reserved for a specific piece of data.

________ is the collection of data items of all the fields pertaining to one entity

The Answer is Field, Record.

Hence the Option A is Correct.